﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.Text;

namespace WoChu.Autorun.Base.Model
{
    [DataContract]
    [MB.Orm.Mapping.Att.ModelMap("WCS_TO_WMS", "WCS_TO_WMS", new string[] { "DETAILNO" })]
    [KnownType(typeof(WCS_TO_WMS))]
    public class WCS_TO_WMS //: MB.Orm.Common.BaseModel
    {
        public WCS_TO_WMS()
        { }
        //明细序号，主键
        private int _DETAILNO;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DETAILNO", System.Data.DbType.Int32)]
        public int DETAILNO
        {
            get { return _DETAILNO; }
            set { _DETAILNO = value; }
        }
        //订单号
        private string _ORDERNO;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ORDERNO", System.Data.DbType.String)]
        public string ORDERNO
        {
            get { return _ORDERNO; }
            set { _ORDERNO = value; }
        }
        //周转箱编号,WMS下发为NULL
        private string _BOXNO;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BOXNO", System.Data.DbType.String)]
        public string BOXNO
        {
            get { return _BOXNO; }
            set { _BOXNO = value; }
        }
        //发货口编号ID
        private string _EXLOCATION;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EXLOCATION", System.Data.DbType.String)]
        public string EXLOCATION
        {
            get { return _EXLOCATION; }
            set { _EXLOCATION = value; }
        }
        //货位编码
        private string _LOCATION;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("LOCATION", System.Data.DbType.String)]
        public string LOCATION
        {
            get { return _LOCATION; }
            set { _LOCATION = value; }
        }
        //商品编号
        private string _ITEMCODE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ITEMCODE", System.Data.DbType.String)]
        public string ITEMCODE
        {
            get { return _ITEMCODE; }
            set { _ITEMCODE = value; }
        }
        //商品名称
        private string _ITEMNAME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ITEMNAME", System.Data.DbType.String)]
        public string ITEMNAME
        {
            get { return _ITEMNAME; }
            set { _ITEMNAME = value; }
        }
        //数量
        private int _QTY;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("QTY", System.Data.DbType.Int32)]
        public int QTY
        {
            get { return _QTY; }
            set { _QTY = value; }
        }
        //实际拣货数量
        private int _PQTY;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PQTY", System.Data.DbType.Int32)]
        public int PQTY
        {
            get { return _PQTY; }
            set { _PQTY = value; }
        }
        //拣货完成时间
        private DateTime _PTIME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PTIME", System.Data.DbType.DateTime)]
        public DateTime PTIME
        {
            get { return _PTIME; }
            set { _PTIME = value; }
        }
        //备注1
        private string _REMARK1;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("REMARK1", System.Data.DbType.String)]
        public string REMARK1
        {
            get { return _REMARK1; }
            set { _REMARK1 = value; }
        }
        //状态处理WCS自用
        private int _STATUS;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("STATUS", System.Data.DbType.Int32)]
        public int STATUS
        {
            get { return _STATUS; }
            set { _STATUS = value; }
        }
        //分拣时间，WMS给默认当前日期
        private DateTime _FINISHTIME;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("FINISHTIME", System.Data.DbType.DateTime)]
        public DateTime FINISHTIME
        {
            get { return _FINISHTIME; }
            set { _FINISHTIME = value; }
        }
        //备注2
        private string _REMARK2;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("REMARK2", System.Data.DbType.String)]
        public string REMARK2
        {
            get { return _REMARK2; }
            set { _REMARK2 = value; }
        }
        //创建时间
        private DateTime _CREATE_DATE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CREATE_DATE", System.Data.DbType.DateTime)]
        public DateTime CREATE_DATE
        {
            get { return _CREATE_DATE; }
            set { _CREATE_DATE = value; }
        }
        //更新时间
        private DateTime _UPDATE_DATE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("UPDATE_DATE", System.Data.DbType.DateTime)]
        public DateTime UPDATE_DATE
        {
            get { return _UPDATE_DATE; }
            set { _UPDATE_DATE = value; }
        }
        //状态：0未处理，1处理完
        private int _FLAG;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("FLAG", System.Data.DbType.Int32)]
        public int FLAG
        {
            get { return _FLAG; }
            set { _FLAG = value; }
        }
        //开始拣货时间
        private string _OTHER1;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER1", System.Data.DbType.String)]
        public string OTHER1
        {
            get { return _OTHER1; }
            set { _OTHER1 = value; }
        }
        //预留
        private string _OTHER2;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER2", System.Data.DbType.String)]
        public string OTHER2
        {
            get { return _OTHER2; }
            set { _OTHER2 = value; }
        }
        //预留
        private string _OTHER3;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER3", System.Data.DbType.String)]
        public string OTHER3
        {
            get { return _OTHER3; }
            set { _OTHER3 = value; }
        }
        //预留
        private string _OTHER4;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER4", System.Data.DbType.String)]
        public string OTHER4
        {
            get { return _OTHER4; }
            set { _OTHER4 = value; }
        }
        //WMS作业波次号
        private string _BATCH_NO;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_NO",System.Data.DbType.String)]
        public string BATCH_NO
        {
            get { return _BATCH_NO; }
            set { _BATCH_NO = value; }
        }
        //库位所在区域
        private string _AREA;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("AREA", System.Data.DbType.String)]
        public string AREA
        {
            get { return _AREA; }
            set { _AREA = value; }
        }
        //开始拣货时间（订单号箱号关联时间）
        private DateTime _BEGIN_DATE;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BEGIN_DATE", System.Data.DbType.DateTime)]
        public DateTime BEGIN_DATE
        {
            get { return _BEGIN_DATE; }
            set { _BEGIN_DATE = value; }
        }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BARCODE", System.Data.DbType.String)]
        public String BARCODE { set; get; }
        //发货口
        private string _EXLocationName;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EXLOCATIONNAME", System.Data.DbType.String)]
        public string EXLOCATIONNAME
        {
            get { return _EXLocationName; }
            set { _EXLocationName = value; }
        }
    }

    [DataContract]
    [MB.Orm.Mapping.Att.ModelMap("WMS_TO_WCS_TASK", "WMS_TO_WCS_TASK", new string[] { "PID" })]
    [KnownType(typeof(WMS_TO_WCS_TASK))]
    public class WMS_TO_WCS_TASK : MB.Orm.Common.BaseModel
    {
        public WMS_TO_WCS_TASK() { }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PID", System.Data.DbType.Int32)]
        public int PID { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DETAILNO", System.Data.DbType.Int32)]
        public int DETAILNO { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ORDERNO", System.Data.DbType.String)]
        public string ORDERNO { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("FBOXNO", System.Data.DbType.String)]
        public string FBOXNO { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EXLOCATION", System.Data.DbType.String)]
        public string EXLOCATION { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("STATUS", System.Data.DbType.Int32)]
        public int STATUS { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CREATE_DATE", System.Data.DbType.DateTime)]
        public DateTime CREATE_DATE { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("UPDATE_DATE", System.Data.DbType.DateTime)]
        public DateTime UPDATE_DATE { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("FLAG", System.Data.DbType.Int32)]
        public int FLAG { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER1", System.Data.DbType.String)]
        public string OTHER1 { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER2", System.Data.DbType.String)]
        public string OTHER2 { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER3", System.Data.DbType.String)]
        public string OTHER3 { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CREATERID", System.Data.DbType.Int32)]
        public int CREATERID { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("UPDATERID", System.Data.DbType.Int32)]
        public int UPDATERID { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CREATER", System.Data.DbType.String)]
        public string CREATER { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("UPDATER", System.Data.DbType.String)]
        public string UPDATER { set; get; }
        //发货口
        private string _EXLocationName;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EXLOCATIONNAME", System.Data.DbType.String)]
        public string EXLOCATIONNAME
        {
            get { return _EXLocationName; }
            set { _EXLocationName = value; }
        }
        //拣货位
        private string _CHECK_LOCATION;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CHECK_LOCATION", System.Data.DbType.String)]
        public string CHECK_LOCATION
        {
            get { return _CHECK_LOCATION; }
            set { _CHECK_LOCATION = value; }
        }
    }

    [DataContract]
    [MB.Orm.Mapping.Att.ModelMap("WCS_TO_WMS_EXCEPTION", "WCS_TO_WMS_EXCEPTION", new string[] { "DETAILNO" })]
    [KnownType(typeof(WCS_TO_WMS_EXCEPTION))]
    public class WCS_TO_WMS_EXCEPTION 
    {
        public WCS_TO_WMS_EXCEPTION() { }

        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DETAILNO", System.Data.DbType.Int32)]
        public int DETAILNO { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ORDERNO", System.Data.DbType.String)]
        public string ORDERNO { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BOXNO", System.Data.DbType.String)]
        public string BOXNO { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EXCEPTIONTYPE", System.Data.DbType.Int32)]
        public int EXCEPTIONTYPE { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EXCEPTIONDES", System.Data.DbType.String)]
        public string EXCEPTIONDES { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CREATER", System.Data.DbType.String)]
        public string CREATER { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CREATEDATE", System.Data.DbType.DateTime)]
        public DateTime CREATEDATE { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EDITOR", System.Data.DbType.String)]
        public string EDITOR { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EDITORDATE", System.Data.DbType.DateTime)]
        public DateTime EDITORDATE { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("REMARK", System.Data.DbType.String)]
        public string REMARK { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CHECK_LOCATION", System.Data.DbType.String)]
        public string CHECK_LOCATION { set; get; }
    }


    [DataContract]
    [MB.Orm.Mapping.Att.ModelMap("WMS_APP_PICK_ORDER", "WMS_APP_PICK_ORDER", new string[] { "PID" })]
    [KnownType(typeof(WMS_APP_PICK_ORDER))]
    public class WMS_APP_PICK_ORDER 
    {
        public WMS_APP_PICK_ORDER()
        { }
        //主键
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PID", System.Data.DbType.Int32)]
        public int PID { set; get; }
        //明细序号
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("DETAILNO", System.Data.DbType.Int32)]
        public int DETAILNO { set; get; }
        //订单号
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ORDERNO", System.Data.DbType.String)]
        public string ORDERNO { set; get; }
        //周转箱编号,WMS下发为NULL
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BOXNO", System.Data.DbType.String)]
        public string BOXNO { set; get; }
        //发货口编号
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EXLOCATION", System.Data.DbType.String)]
        public string EXLOCATION { set; get; }
        //货位编码
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("LOCATION", System.Data.DbType.String)]
        public string LOCATION { set; get; }
        //商品编号
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ITEMCODE", System.Data.DbType.String)]
        public string ITEMCODE { set; get; }

        //商品69条形码
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BARCODE", System.Data.DbType.String)]
        public string BARCODE { set; get; }
        //商品名称
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("ITEMNAME", System.Data.DbType.String)]
        public string ITEMNAME { set; get; }
        //数量
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("QTY", System.Data.DbType.Int32)]
        public int QTY { set; get; }
        //实际拣货数量
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PQTY", System.Data.DbType.Int32)]
        public int PQTY { set; get; }
        //拣货完成时间
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("PTIME", System.Data.DbType.DateTime)]
        public DateTime PTIME { set; get; }
        //备注1
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("REMARK1", System.Data.DbType.String)]
        public string REMARK1 { set; get; }
        //状态处理WCS自用
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("STATUS", System.Data.DbType.Int32)]
        public int STATUS { set; get; }
        //分拣时间，WMS给默认当前日期
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("FINISHTIME", System.Data.DbType.DateTime)]
        public DateTime FINISHTIME { set; get; }
        //备注2
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("REMARK2", System.Data.DbType.String)]
        public string REMARK2 { set; get; }
        //创建时间
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("CREATE_DATE", System.Data.DbType.DateTime)]
        public DateTime CREATE_DATE { set; get; }
        //更新时间
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("UPDATE_DATE", System.Data.DbType.DateTime)]
        public DateTime UPDATE_DATE { set; get; }
        //状态：0未处理，1处理完
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("FLAG", System.Data.DbType.Int32)]
        public int FLAG { set; get; }
        //开始拣货时间
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER1", System.Data.DbType.String)]
        public string OTHER1 { set; get; }
        //预留
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER2", System.Data.DbType.String)]
        public string OTHER2 { set; get; }
        //预留
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER3", System.Data.DbType.String)]
        public string OTHER3 { set; get; }
        //预留
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("OTHER4", System.Data.DbType.String)]
        public string OTHER4 { set; get; }
        //WMS作业波次号
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BATCH_NO", System.Data.DbType.String)]
        public string BATCH_NO { set; get; }
        //库位所在区域
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("AREA", System.Data.DbType.String)]
        public string AREA { set; get; }
        //开始拣货时间（订单号箱号关联时间）
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("BEGIN_DATE", System.Data.DbType.DateTime)]
        public DateTime BEGIN_DATE { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("USERID", System.Data.DbType.Int32)]
        public int USERID { set; get; }
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("USERNAME", System.Data.DbType.String)]
        public string USERNAME { set; get; }
        //发货口
        private string _EXLocationName;
        [DataMember]
        [MB.Orm.Mapping.Att.ColumnMap("EXLOCATIONNAME", System.Data.DbType.String)]
        public string EXLOCATIONNAME
        {
            get { return _EXLocationName; }
            set { _EXLocationName = value; }
        }
    }
}
